package com.dhecp.project.storage.mapper;

import com.dhecp.project.storage.domain.HwReconcileCkson;
import com.dhecp.project.storage.domain.HwTailprogram;

import java.util.List;
import java.util.Map;
import com.dhecp.core.genericDao.GenericDao;
import org.apache.ibatis.annotations.Param;

/**
 * 海外仓尾程单(HwTailprogram)表数据库访问层
 *
 * @author fxz
 * @since 2023-09-08 10:07:47
 */
public interface HwTailprogramMapper extends GenericDao<HwTailprogram, String>{

       /**
    * 查询列表数据
    */
    List<HwTailprogram> queryList(Map<String, Object> params);
    /**
     * 通过ID查询单条数据
     *
     * @param params 参数
     * @return 实例对象
     */
     HwTailprogram queryFirstRecord(Map<String, Object> params);

     int updateStateName(HwTailprogram hwTailprogram);

    /**
     * 批量修改
     *
     * @param hwTailprogramList
     */
    int batchUpdateNew( List<HwTailprogram> hwTailprogramList);

    List<HwTailprogram> findHwTailprogramBatch(List<HwTailprogram> hwTailprogramList);

    List<HwTailprogram> queryListSelect(Map<String, Object> params);

    /**
     *@Description: 修改状态
     */
    int updateState(@Param("bid")String bid, @Param("stateName")String stateName);

    /**
     * 按照月份查询尾程的数据
     * @return
     */
    List<HwReconcileCkson> listDateAndOverseasName(@Param("year")String year, @Param("mouth")String mouth, @Param("overseasName")String overseasName);
}

